[Logging]
Level=Info
LogSql=True
LogSqlThresholdMSec=200
LogToConsole=Info
LogToFile=All
LogToFileAutoFlush=True

[Database]
providerName=System.Data.SqlClient
ConnectionString=Data Source=RS-SRV012;  User ID=sa; Current Language=Thai;

[Dbase]
Base =[BIAS-STOCK_DEV]
Bias = TireBias
TIRSTD = biasbc_usr

[Database2]
providerName=System.Data.SqlClient
ConnectionString=Data Source=RS-SRV012;  User ID=sa; Current Language=Thai;

#HN-38MH+L+2.50-17NR74/L+STB+15/08-1-STB+26/08/2013+50+1+3+25/02/2014-10-1
select 
--HN-38MH+L+   2.50-17NR74/L+  STB+  15/08-1-STB  +26/08/2013+  50+1+3+25/02/2014-10-1
topcrdcd +'+'+side+'+'+sizes+'+'+forming+'+'+plylot+'+'+convert(varchar(12),plyexp,103)
+'+'+convert(varchar,plylen)+'+'+convert(varchar,rollno)+'+'+convert(varchar,biasno)+'+'+ convert(varchar(12),plandt,103)+'-'+convert(varchar,itemno)+'-'+convert(varchar,sitemno)
 ,cartno from dbo.allRelation
order by plandt desc,convert(int,cartno)
